package soft.edu.dao;

import org.apache.ibatis.annotations.Param;
import soft.edu.pojo.SchExamArea;
import soft.edu.pojo.SchExamAreaWithBLOBs;

import java.util.List;

public interface SchExamAreaMapper {
    int deleteByPrimaryKey(Integer exaId);

    int insert(SchExamAreaWithBLOBs record);

    int insertSelective(SchExamAreaWithBLOBs record);

    SchExamAreaWithBLOBs selectByPrimaryKey(Integer exaId);

    int updateByPrimaryKeySelective(SchExamAreaWithBLOBs record);

    int updateByPrimaryKeyWithBLOBs(SchExamAreaWithBLOBs record);

    int updateByPrimaryKey(SchExamArea record);

    //注解Param的作用是：SQL语句中的查询要与注解中的string保持一致
    //根据院校、学院、专业名称获取考试范围信息
    List<SchExamArea> getInfo(@Param("year") String year,
                              @Param("exa_uni_name") String exa_uni_name,
                             @Param("exa_college_name") String exa_college_name,
                             @Param("exa_maj_name") String exa_maj_name);

}